package mobi.hami.huapin.dao;

import java.util.List;

import mobi.hami.huapin.daobase.CrudMapper;
import mobi.hami.huapin.model.SkuAffiliatedinfo;
import mobi.hami.huapin.model.SkuAffiliatedinfoExample;
import mobi.hami.huapin.model.SkuPictureMapping;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface SkuAffiliatedinfoMapper extends CrudMapper<SkuAffiliatedinfo> {

    @Select("<script>"
            + "SELECT * FROM sku_affiliatedinfo  where deleted=0 and skuid=#{skuid}"
            + "</script>")
    SkuAffiliatedinfo  selectAffiliatedinfo(int skuid);

    @Select("<script>"
            + "SELECT  * FROM sku_affiliatedinfo  where deleted=0 and  skuid=#{skuid} limit 0,1"
            + "</script>")
    SkuAffiliatedinfo isInfo(int skuid);
}